/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select * from customer where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table customer \
-m 1
   --- customer_relationship

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,substring(create_date_time,1,7)as dt from customer_relationship where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table customer_relationship \
-m 1



-----customer_appeal

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,substring(create_date_time,1,7)as dt from customer_appeal where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table customer_appeal \
-m 1

---dim_employee

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,substring(create_date_time,1,7)as dt from employee where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table employee \
-m 1

--scrm_department

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,substring(create_date_time,1,7)as dt from scrm_department where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table scrm_department \
-m 1

-- itcast_school

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,substring(create_date_time,1,7)as dt from itcast_school where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table itcast_school \
-m 1

-- itcast_subject
/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,substring(create_date_time,1,7)as dt from itcast_subject where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table itcast_subject \
-m 1

-- customer_clue

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,'2023-09-20' as dt  from customer_clue where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table customer_clue \
-m 1


 -- itcast_clazz

/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/scrm?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *,substring(create_date_time,1,7)as dt from itcast_clazz where 1=1 and  \$CONDITIONS" \
--hcatalog-database ods \
--hcatalog-table itcast_clazz \
-m 1